2015-12-15 - 9203.1100 - Enhancement - Sell Thru Data flow changes #SalesDistribution
Enhancement
9203.1000 - Sell-Thru Data Flow Changes
Purpose
Need to change the Sell Thru data flow changes as per the business logic.
Admin Info
Purpose
|
Need to change the Sell Thru data flow changes as per the business logic.
|
Requested By
|
Bill Adams
|
Spec Created By
|
Naveen G
|
Spec Created Date
|
12/15/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZSD_OSEL and ZSD_SELT
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
01
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
24
|
4
|
Unit test in DEV
|
06
|
5
|
Unit test in QUA
|
04
|
6
|
Transports
|
01
|
|
TOTAL
|
40
|
References
Prior Tickets
9203.900
9203.1000
Documents
KOHLS_SELL_THRU_UPC_SAMPLE.xlsx
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Need to optimize the start routine logic in sell thru source
|
Greg Jackson
|
12/21/2015
|
Implemented
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Email from Greg Jackson on 12/12/2015:
An overall format for sell thru was discussed and handed out for the business to use. In the new format, there are multiple ways for customers to give us a material number. These include Customer UPC, Customer MID, NEC UPC, or NEC MID. Depending on what field is filled in, we would have to do the lookup accordingly. Customer UPC or Customer MID would use the current logic depending on which one is filled in. NEC UPC would do a lookup against ZMAT_GRID to get the material/size. Then obviously if the customer gave us our NEC MID then we wouldn't have to do any logic. The file attached is what Kohls gave us. The only change I made was saving it as an XLSX file so that it would compress for sending. The file actually has "Customer UPC" populated, but these UPC numbers are actually NEC UPC numbers. So in this case we would actually want to move the UPC numbers to the correct column.
So what needs to be done is to add logic to lookup NEC UPC's via ZMAT_GRID. The new requirement that we have given to customers to make this work is to included NEC UPC. So this means we can comment out the customer UPC and MID logic for now. Don't delete it, just comment it out. Going forward, we are going to try to always get NEC UPC and do the lookup that way. If a customer comes back and gives us their MID or UPC, then we can just reactivate the logic. When it comes to that, we can organize the logic accordingly to do the fastest logic first.
Email from Greg Jackson on 12/21/2015:
Sell thru seems to be working well except for the customer lookup doesn’t work every time. This is because the master data loads from ECC on the field 0AF_CUSTID aren’t consistent. Sometimes the stores don’t have leading zeros, other times they do. When they do have leading zeros, sometimes one, two, or even three leading zeros. Just so that you are aware, in the customer master [0CUSTOMER], I am adding code to 0AF_CUSTID to always cutoff all leading zeros so that it’s always consistent. Would you agree with this approach? With this change, the data took a very long time to load.
In Scope:
Implement the new logic in start routine without any changes to the old logic.
Out of Scope:
Need to replace the old logic back if business needs the data as per old logic.
Solution Summary
1. Need to add EAN UPC code into sell thru DSO & infocube.
2. Need to write the new logic in start routine to populate material based on UPC as defined by NEC by commenting the old logic.
3. Need to collect all the changes into the transport request.
4. Need to validate the data in BPD & BPQ.
Test Plan : BPD
SNo
|
Test Case
|
Results
|
1
|
Need to check if the material & Grid value is getting populated as per the logic.
|
Material & Grid value are populated successfully as per the logic.
|
2
|
Need to optimize the logic to improve data loading performance.
|
Logic is tuned so that the data loading gets completed quickly.
|
2
|
Need to check if all the objects are collected into the transport request.
|
All the changes collected into the transport request successfully.
|
Solution Details
1. Need to add 0EANUPC info object into sell thru DSO ZSD_OSEL & infocube ZSD_SELT.
2. Need to write the new logic in start routine to populate material(0MATERIAL) based on UPC(0EANUPC) as defined by NEC by commenting the old logic.
3. Need to collect all the changes into the transport request.
4. Need to validate the data in BPD & BPQ.
Issues
Since the datasource/extractor changes are not done, need to update UPC data to Customer Material field.